Towards a logical framework for OLAP query log manipulation
نویسندگان
چکیده
This paper proposes a manipulation language tailored for OLAP query logs, stemming from the relational algebra. This language is based on binary relations over sequences of queries (called sessions). We propose two such relations allowing to group and order sessions. Examples of expressions in this language illustrate its interest for various user-centric approaches, like query recommendation or log summarization, particularly relevant in the context of data warehouse exploration.
منابع مشابه
A Logical Framework for Querying
We address the issue of designing e ective query languages for OLAP databases. The basis of our investigation is MD, a logical data model for multidimensional databases that, unlike other multidimensional models, is independent of any speci c implementation. As such, MD provides a clear separation between practical and conceptual aspects of multidimensional analysis. In this framework, we prese...
متن کاملA Logical Framework for QueryingMultidimensional Data
We address the issue of designing eeective query languages for OLAP databases. The basis of our investigation is MD, a logical data model for multidimensional databases that, unlike other multidimensional models, is independent of any speciic implementation. As such, MD provides a clear separation between practical and conceptual aspects of multidimen-sional analysis. In this framework, we pres...
متن کاملSummarizing and Querying Logs of OLAP Queries
Leveraging query logs benefits the users analyzing large data warehouses with OLAP queries. But so far nothing exists to allow the user to have concise and usable representations of what is in the log. In this article, we present a framework for summarizing and querying OLAP query logs. The basic idea is that a query summarizes another query and that a log, which is a sequence of queries, summa...
متن کاملCAL: A Generic Query and Analysis Language for Data Warehouses
Data warehouses (DWs) and OLAP systems are essential tools in organizational decision making. However, users of these systems are often provided with complex data models and system-specific GUIs and dashboards to analyze the data and generate reports. Available DW query languages like MDX and Oracle OLAP support only numeric data and moreover require skilled DW developers to design queries. Thi...
متن کاملQuery-Driven Knowledge Discovery via OLAP manipulations
We study KDD (Knowledge Discovery in Databases) processes on OLAP (multidimensional and multilevel) data from a query point of view. Focusing on association rule mining, we consider typical queries to cope with the pre-processing of multidimensional data and the post-processing of the discovered patterns as well. We use a model and a rule-based language stemming from the OLAP representation and...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2012